[dbo].[FieldDesign]

Property	Value
Created	10:31:22 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

10:31:22 AM Tuesday, March 02, 2010

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)	Identity
	FieldDesignId	int	4	1 - 1
$Indexes iWC: TableName\FieldName\MemberTypes$	TableName	varchar(30)	30
$Indexes iWC: TableName\FieldName\MemberTypes$	FieldName	varchar(30)	30
	FieldState	int	4
	RegularExpression	varchar(255)	255
	RegularExpressionExample	varchar(255)	255
$Indexes iWC: TableName\FieldName\MemberTypes$	MemberTypes	varchar(255)	255

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

FieldDesignId

int

1 - 1

$Indexes iWC: TableName\FieldName\MemberTypes$

TableName

varchar(30)

$Indexes iWC: TableName\FieldName\MemberTypes$

FieldName

varchar(30)

FieldState

int

RegularExpression

varchar(255)

255

RegularExpressionExample

varchar(255)

255

$Indexes iWC: TableName\FieldName\MemberTypes$

MemberTypes

varchar(255)

255

	Name	Columns	Unique
	PK_FieldDesign	FieldDesignId
	iWC	TableName, FieldName, MemberTypes

Name

Columns

Unique

PK_FieldDesign

FieldDesignId

iWC

TableName, FieldName, MemberTypes

SQL Script

CREATE TABLE [dbo].[FieldDesign]
(
[FieldDesignId] [int] NOT NULL IDENTITY(1, 1),
[TableName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FieldName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FieldState] [int] NOT NULL,
[RegularExpression] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RegularExpressionExample] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MemberTypes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[FieldDesign] ADD CONSTRAINT [PK_FieldDesign] PRIMARY KEY CLUSTERED ([FieldDesignId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iWC] ON [dbo].[FieldDesign] ([TableName], [FieldName], [MemberTypes]) ON [PRIMARY]
GO